drop table art
create table art(
id int identity,
inserted datetime,
srcChar char,
title varchar(500),
content text,
kaywords varchar(500),
srcId int,
srcLink varchar(200),
img varchar(500),
sent char default 'N',
constraint pk_art_id primary key(id)
)
go
sp_help art


drop table car
create table car(
id int identity,
inserted datetime default getdate(),
srcId varchar(20),
title varchar(500),
miles int,
distance int,
bodytype char,
year int,
seller char,
trans char,
price int,
engine varchar(5),
fuel char,
imgs varchar(1000),
constraint pk_car_id primary key(id)
)


create table artSrc(
id int identity,
inserted datetime,
rss varchar(100),
portalChar char,
constraint pk_artCtrl_id primary key(id)
)


create table carSrc(
id int identity primary key,
inserted datetime default getdate(),
link varchar(500)
)